SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Select records from the MessageConfig table through an index
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.MessageConfig_GetByKeyCode
(

	@KeyCode varchar (15)  
)
AS


				SELECT
					[KeyCode],
					[Value],
					[TypeId],
					[Language],
					[CreatedDate],
					[UpdatedDate],
					[CreatedUser],
					[UpdatedUser]
				FROM
					[dbo].[MessageConfig]
				WHERE
					[KeyCode] = @KeyCode
				SELECT @@ROWCOUNT
					
			

GO
